Error In Spring Using JDBC

Aug 7, 2014

public class StudentJDBCTemplate implements StudentDao

above class giving error as

The type StudentJDBCTemplate must implement the inherited abstract method

StudentDao.listStudents()

Interface is as below

import java.util.List;
import javax.sql.DataSource;
public interface StudentDao {
public void setDataSource(DataSource ds);
public void Create(String Name,Integer age);
public void getStudent(Integer id);
public List<Student>listStudents();
public void delete(Integer id);
public void update(Integer id,Integer age);
}

View Replies


ADVERTISEMENT

JDBC :: IO Error - Network Adapter Could Not Establish Connection

Jan 24, 2015

Yesterday, I established a connection with oracle 12c, codes is here:
 
ods.setURL("jdbc:oracle:thin:c##mytest/myt@//myhost:1521/orcl");Connection conn=ods.getConnection(); 
where "c##mytest/myt" is username and password. It worked well.

But, today, "IO Error:The Network Adapter could not establish the connection" appeared when I tried to run my program again.

I changed //myhost into 127.0.0.1, it worked again.(Before I did this, I checked lsnrctl and regedit and firewall....., no difference)

Here is my question:

1) What happens between //myhost to 127.0.0.1, hostname cannot be use to JDBC? If yes, how?
 
Besides, I have some other questions:
 
2) How import a *.dmp file which exported from 10g into 12c?
 
3)If I need upgrade 10g to 12c, what shall I do?

View Replies View Related

JDBC :: How To Call Parameterized Stored Procedure In Jdbc

May 17, 2014

calling a parameterized stored procedure in java jdbc from sql server.The stored procedure goes like this in sql

create proc patientreg
@id int
as
begin
select [patient_id],[Psurname], [pFirstname], [pMiddlename], [reg_date], [DOB], [Sex], [Phone_num], [Addr],[Email],[dbo].[fncomputeage](DOB) from [dbo].[Patient_registration] where [patient_id] = @id
end
please note dbo.fncompute(DOB) is a function

To call it in jdbc it goes like this

try{
String str = "{call patientreg(?)}";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbcdbc:GeneralHospit al");
cstmt = con.prepareCall(str);
cstmt.setInt(1, Integer.parseInt(t.getText()));

[code]....

after doing it this way it throwing an exception: Error:java.sql.SQLException: Parameter 1 is not an OUTPUT parameter.

View Replies View Related

How To Import A Spring Application

Apr 21, 2015

I have imported several maven projects but I am trying to import a spring project via eclipse and it is not displaying. I did the following file->import->Existing maven projects->browse (found my project)->finish..... The project does not display and I cannot find it. I tired to do it again and the project cannot import because I cannot select it meaning it is already installed.

View Replies View Related

Spring Integration Test

Nov 18, 2014

In my integration test, I tried to use resttemplate to send a Get request to a dummy server created by MockMvcBuilders. However I got an error:I/O error on GET request for `"http://localhost:8080/test"`:Connection refused:(In the function testAccess(), url is `"http://localhost:8080/test"`). My code is as below:

@RunWith(SpringJUnit4ClassRunner.class)
@WebAppConfiguration
@IntegrationTest("server.port=8080")
public class MyTest {
private MockMvc mockMvc = null;

[code]....

View Replies View Related

Custom Annotations And Spring MVC

Jan 23, 2015

I'm running spring MVC on a tomcat server and am fiddling around with beans and annotations.

First, I have a class Library, with a registerBook(<T> Book) method. This one is annotated with @BookRegistry

Next, I have an Interface Book, which basically is a bean with some custom methods.

I will create different types of books that implement my Book interface and annotate them with @LibraryBook

Now, I want to have spring to check for all beans with @LibraryBook at server startup and run registerBook for each and every one.

How do I accomplish this?

View Replies View Related

Spring MVC3 With Hibernate

Oct 10, 2014

My requirement is to display a table containing multiple rows and multiple columns. and row headers must be link type and that table should be retrieved dynamically from db where the values entered by the admin. this is the user view. and am new to spring. unable to implement this. my demo is on monday and i need to show the demo to survive in this job. I had given the link. but am unable to implement by seeing that also because it has no complete code which is my actual requirement. Code should be written in controllers, pojo, dao's, jsp's etc... URL....

In my code am unable to get in one table. So I went with alternative that to come each row and 3 columns in one table... 4 rows 4 different tables I did... but it was not my requirement. I used embedded to get that...in my pojo I wrote

@Embedded private BaseCost baseCost;
@Embedded private OtherCharges otherCharges;
@Embedded private PreferentialLocationalCharges preferentialLocationalCharges;
@Embedded private CarParking carParking;

and each embedded one i have created 4 pojo's where i wrote column headers. get it all in one table view with 4 row headers and 3 column headers but this is not my requirement...

View Replies View Related

Swing/AWT/SWT :: Spring Layout Odd Sizing

Mar 12, 2015

I create a spring layout like so

Container contentPane = this.getContentPane();
JLabel characterLabel = new JLabel("Character: ");
JComboBox<String> characterComboBox = new JComboBox<String>();
characterLabel.setMinimumSize(characterComboBox.getMinimumSize());

[Code] ....

and I have attached an image of the results.

Why are the drop down boxes not stretched to the right all the way and why are they so tall?

View Replies View Related

Spring MVC - Java Based Configuration

Aug 16, 2014

For some time i've been trying to rewrite my XML configurated webapp into one that has Java Based cofiguration. Unfortunately ,even after going through many tutorials i've been unable to do so.

View Replies View Related

JAMON Spring Unable To Monitor Exceptions

Jul 12, 2014

I am currently working on integrating JAMON version 2.76 in our existing application

following are details of environment
JDK 1.5
Server weblogic 9.2
OS windows
Spring version 2.5

first we have added following entry for jamon monitor

<bean id="jamonPerformanceMonitor" class="org.springframework.aop.interceptor.JamonPerformanceMonitorInterceptor">
<property name="useDynamicLogger" value="false"/>
<property name="trackAllInvocations" value="true"/>
</bean>

then added this interceptor as preinterceptor in existing

<bean id="applicationBO" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager"/>
</property>

[Code].....

currently we can able to monitor all calls given to this class but whenever any exception thrown in this class hierarchy we are not able to track it on exceptions.jsp of JAMON

View Replies View Related

JSF :: Similarities Between Faces Flows And Spring Web Flow

Aug 8, 2014

URL....In the mentioned project in this blog I used Spring Web Flow to satisfy some requirements but now that development of the Spring Web Flow stopped I like to check what Faces Flows can present to satisfy the same requirements.From a quick look similarities between Spring Web Flow and Faces Flows are obvious but there is one specific point I like to ask.In SWF it is possible to define flowing element at the beginning of an flow.

<on-start>
<evaluate expression="CustomerSearchSM.resetStateMachine()"/>
</on-start>

which will trigger an event when you will start executing a flow, I look to the Faces Flows flow descriptors but I can see an element that fullify similar requirement.similar functionality built into the Faces Flow or not?And is there a way to configure Faces Flows that it reacts to events from the users like the following.

<transition on="onStartCustomerSearch" history="invalidate">
<evaluate expression="customerSearchInputBB.searchCustomer()"/>
</transition>
<transition on="onCustomerAuthenticated" history="invalidate">
<evaluate expression="customerSearchAuthenticationBB.customerGivesAuthentication()"></evaluate>
</transition>

View Replies View Related

Accessing Spring Property Placeholder From JavaScript In JSP

Jun 20, 2014

I am trying to find a way to make a URL that is used during a background AJAX call to log a user out more flexible. Currently, I have it as a static value, as below:

var logoutURLTest = "https://test.myorg.com/cas/logout";
...AJAX stuff that uses the logoutURLTtest variable...

However, if that URL was to change for any reason, I would have to modify one or more JSPs if they were affected, instead of just changing it at a single point in the Spring environment context. It would be more desirable to expose the value using a property placeholder; however, the Spring documentation isn't exactly clear on whether this is possible.

View Replies View Related

JSP :: Doesn't Display Message See Code Spring Mvc

May 10, 2014

in my ui i will i will select enabled or disabled then it will go in controller , i already debug it and it goes on the right controller based on what i select on ui my problem is when i select disabled it dont display the message but when i select enabled it displays the message, then i check the databases status is change based on what i select but when i change into disabled doesnt display any message.if select enabled will go in controller then change status into true then update the status then will see the message in ui

@RequestMapping(value = "/viewEnabled/{id}", method = RequestMethod.POST)
public ModelAndView viewEnabled(
@PathVariable("id") Integer id) {
ModelAndView mvc = new ModelAndView();
Supplier supplier = supplierService.retrieveSupplier(id);
supplier.setEnabled(true);
supplierService.updateSupplierEnabled(supplier);
mvc.addObject("showEnabled", true);
mvc.addObject("supplier", supplier);

[code]....

The main functionality of enabled /disabled is both working it just dont display the message if i change it into disabled,.

View Replies View Related

How To Pass Java Object Into Spring Controller

Jan 7, 2014

When I hit the url at the first time my call goes to the spring controller and sets the userDetails objects in the modelAndView.addObject("userDetails", userDetails.getUserDetails()) and returns the userDetails.html page. if I click any link in the same page i want to pass same (userDetails) object thru javascript or jquery and calls the another(controller) method and returns the same (userDetails.html) page.

It means how can I pass the java object thru javascript or jquery and calls the controller. If I get the same object in my controller i can avoid calling the db again.

View Replies View Related

JSF :: View Layer And Handling Business Logic - Hibernate Without Spring

Jun 30, 2014

I am going to develop a new web application of medium complexity. Right now i am somewhat comfortable with JSF and hibernate. I have never used JSF and hibernate together before.I just wanted to ask if it is good practice to use JSF (for both view layer and handling business logic) and hibernate(for persistence) without spring as a middle layer. The reason why i am asking this is i don't know anything about spring framework.

View Replies View Related

Enterprise JavaBeans :: Weblogic JNDI Lookup Fails Via Spring

Feb 24, 2014

There is a weblogic server running at remote place and i need to access the API's in that remote method using JNDI lookup. My application is configured in Spring Tool Suite IDE with java 6 and tomcat 7 and I have used Spring to perform the jndi lookup of weblogic server. In spring i have used simpleremotestatelesssessionproxyfactorybean class to lookup a weblogic server using jndi and get the remote object. But somehow on doing it i'm getting the following error.
 
org.omg.CORBA.COMM_FAILURE:   vmcid: SUN  minor code: 203 completed: Maybe
       at com.sun.corba.se.impl.logging.ORBUtilSystemException.writeErrorSend(Unknown Source)
       at com.sun.corba.se.impl.logging.ORBUtilSystemException.writeErrorSend(Unknown Source)
       at com.sun.corba.se.impl.transport.SocketOrChannelConnectionImpl.sendWithoutLock(Unknown Source)
       at com.sun.corba.se.impl.encoding.BufferManagerWriteStream.sendFragment(Unknown Source)

[Code] ....

The exception is been thrown at com.sun.corba.se.impl.encoding.CDROutputObject method when calling writeTo(). Why I'm getting this error and can I do anything to remediate it. Irrespective of java this error occurs, i tried with java 5, 6 and 7 but still getting the same error.

View Replies View Related

EJB / EE :: Relationship Between JAAS And JDBC

Aug 9, 2014

I'm trying to understand the relationship between JAAS and JDBC..In WebSphere, when setting up a Dynamic cluster I have to first define the JAAS..Then, the datasource..The JAAS has one account/password and the datasource another..I'm not getting the relationship between needing both JAAS and JDBC docs.oracle.com/cd/E19225-01/820-5594/ahteo/index.html

View Replies View Related

JDBC :: How To Retrieve Just One Value From Database

Nov 25, 2014

I wish to retrieve just one value from db;
 
so I use this code:

@Transactional
    public long getSequenceSedeB(Long id) {
        BigDecimal seqValue = nu
        String sql = "SELECT MAX(ID) FROM SEDE_B_ALLEGATI_A WHERE ID_SEDE=:id";
        SQLQuery query = getSession().createSQLQuery(sql);

[Code] ....

But it do not works; this is the log.

type.NullableType (NullableType.java:182) - could not read column value from result set: ID; Invalid column name

2014-11-25 14:45:14,476 WARN  [btpool0-2] util.JDBCExceptionReporter (JDBCExceptionReporter.java:77) - SQL Error: 17006, SQLState: null
2014-11-25 14:45:14,478 ERROR [btpool0-2] util.JDBCExceptionReporter (JDBCExceptionReporter.java:78) - Invalid column name

 But in the database the query
 
SELECT MAX(ID) FROM SEDE_B_ALLEGATI_A WHERE ID_SEDE=:id
 
run correctly;
 
Also I need to rewrite the statement
   query.setParameter("id", 923);
in this way
   query.setParameter("id", AAA);
 
where AAA is gotten from out of the procedure;

View Replies View Related

JDBC :: Restore Database In Java

Feb 26, 2015

I'm having problem with my code when it comes to Restore Database in Java. This is my code:

public boolean restoreDB(String dbUserName, String dbPassword, String source) {
String[] executeCmd = new String[]{"C:Program Files (x86)MySQLMySQL Server 5.1inmysqldump ", "--user=" + "root", "--password=" + "1234" + source};
Process runtimeProcess;
try {
runtimeProcess = Runtime.getRuntime().exec(executeCmd);
int processComplete = runtimeProcess.waitFor();

[Code] ....

View Replies View Related

JDBC In OSGI - Table Does Not Have Index

Oct 4, 2013

To insert 500 records into oracle my code is taking more than 1 minute.

I am using the below:
1) dbcp connection pool
2) Jdbc, autocommit off
3) preparestatment
4) batchupdate
5) deployed in fuse servicemix

Important thing : Table doesnot have index.

How to improve the performance. Below is the code snippet..

// Added for Transaction
conn.setAutoCommit(false);
conn.setTransactionIsolation(Connection.TRANSACTION_SERIALIZABLE);
PreparedStatement dataStmt= null;
dataStmt= conn.prepareStatement("insert statement");
for (Value value : valueList){

[Code] .....

View Replies View Related

JDBC Update Exception - Too Few Parameters

Jul 22, 2014

So, first i search the id from table and all the fields are filled as in the screenshot. then i modify in the text boxes and click on button modify but exception comes-too few parameters. expected 6.

here is the code:

try
{
JOptionPane.showMessageDialog(null,"Record succefully modified!
ID is "+id.getText()+" Password is "+lname.getText());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("Jdbc:Odbc:Employe eDB");
String str0=id.getText();

[Code] ....

View Replies View Related

JDBC :: BatchUpdate Rows Affected Is Always -2

Mar 27, 2015

I have a batch process which does Bulk UPDATE statement.

After implementing batch support using Spring JDBC 4.1.6 and Oracle Jdbc Driver (ojdbc7 and ucp), the number of records affected for individual update requests (in the batch) are always retrieved as -2 (Statement.SUCCESS_NO_INFO).

Is there any way to know the rows affected for individual cases, as I have to retry the same argument with an INSERT statement after this. Technically trying to develop this as an UPSERT implementation

I tried this batch update in Three Different Ways, and in all three methods the results are same -- (It just tells me Statement.SUCCESS_NO_INFO (-2) )

Method 1  -- Direct UCP Connection and PreparedStatement
        connectionPoolMgr.startConnectionPool("mgr_pool");
        Connection connection = pds.getConnection();
       
        PreparedStatement pstmt = connection.prepareStatement(dmlSQL);
        pstmt.setInt(1, pkId);
        pstmt.setInt(2, idx * 10);
        pstmt.addBatch();
 
[Code] .....

View Replies View Related

JDBC :: Open Connection String

Jun 25, 2015

What I have in my tnsnames.ora and verify it all works via sqlplus
 
CDB1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cdb1)
 
[Code] ....
 
I am trying to get RJDBC to work so I can connect to Oracle from R doing some data analysis..
 
This connection string works for my local db which I have it running in my Virtual Box
 
con <- dbConnect(drv, "jdbc:oracle:thin:@//localhost:1521/orcl", "demo", "demo")
 
However, it does not work when I do it for the remote db that I really need to pull data from...
 
> con <- dbConnect(drv, "jdbc:oracle:thin:@//ymsdbppr-scan:1522/YMQCTPRD", "user_read", "user_read")

Error in .jcall(drv@jdrv, "Ljava/sql/Connection;", "connect", as.character(url)[1],  :
  java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS: listener does not currently know of service requested in connect descriptor

View Replies View Related

JDBC :: Maximum Number Of Connections

Feb 29, 2012

I am using a static initialization block to register the driver and a static synchronized method to get a connection. The problem is I need to run 15 threads but always only two threads get the connection. I want to know if there is a default maximum number of concurrent connections a DriverManager can provide or is it my threading logic that may be faulty.

CODE:

static {
     try {
Class jdbcDriverClass = Class.forName( JDBC_DRIVER );
driver = (Driver) jdbcDriverClass.newInstance();
DriverManager.registerDriver( driver );

[Code] ....

View Replies View Related

JDBC :: Double Value Infinity Causes IllegalArgumentException

Feb 23, 2015

Trying to bind the value Double.POSITIVE_INFINITY in a prepared statement causes an IllegalArgumentException using ojdbc6 11.2.0.4.0 but it works fine in version 11.2.0.3.0:
 
Exception in thread "main" java.lang.IllegalArgumentException: Overflow
    at oracle.jdbc.driver.OraclePreparedStatement.setDoubleInternal(OraclePreparedStatement.java:7605)
    at oracle.jdbc.driver.OraclePreparedStatement.setDouble(OraclePreparedStatement.java:7513)
    at

[Code]....
 
The database used is 'Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production'. I don't see any mention regarding changes to this in the 11.2.0.4.0 change log. Is this a bug in the driver or is there some other explanation?

View Replies View Related

JDBC Connectivity With MySQL Database

Apr 24, 2014

I created a database in mysql, but I have problems communicating with the DB in java.

Here is the error :

java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/books
at java.sql.DriverManager.getConnection(DriverManager.java:604)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at displayauthors.DisplayAuthors.main(DisplayAuthors.java:30)
java.lang.NullPointerException

[Code] ....
 
HERE IS THE CODE 

public class DisplayAuthors {   
// database URL                             
   static final String DATABASE_URL = "jdbc:mysql://localhost:3306/books";
   // launch the application
   public static void main( String args[] )

[Code] ....

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved