I made select work with jboss now, this means the finder will work, and
the loader still not work, I got error say " Unable to create
PreparedStatement"
Thanks.
the conf:
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=DevODBC">
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
</attribute>
<attribute name="PoolName">DevODBC</attribute>
<attribute
name="URL">jdbc:microsoft:sqlserver://intranet:1433</attribute>
<attribute name="Properties">DatabaseName=ctbs_dev</attribute>
<attribute name="Properties">SelectMethod=cursor</attribute>
<attribute name="JDBCUser">dev</attribute>
<attribute name="Password">dev</attribute>
</mbean>
The exception:
[Teacher] Activated bean Teacher with id = Maggid Hockett
[JAWS] Load command executing: SELECT
SVR_TEACHER.name,SVR_TEACHER.school,SVR_TEACHER.pwd,SVR_TEACHER.last_vis
it,S
VR_TEACHER.subject,SVR_TEACHER.grade_level,SVR_TEACHER.gender,SVR_TEACHE
R.de
scription,SVR_TEACHER.district FROM SVR_TEACHER WHERE name=?
[JAWS] java.sql.SQLException: Unable to create PreparedStatement!
[JAWS] at
org.jboss.pool.jdbc.xa.wrapper.XAClientConnection.prepareStatement(XACli
entC
onnection.java:169)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.jdbcExecute(JDBCCommand.java
:158
)
[JAWS] at
org.jboss.ejb.plugins.jaws.jdbc.JDBCLoadEntityCommand.execute(JDBCLoadEn
tity
Command.java:147)
[JAWS] at
org.jboss.ejb.plugins.jaws.JAWSPersistenceManager.loadEntity(JAWSPersist
ence
Manager.java:156)
[JAWS] at
org.jboss.ejb.plugins.CMPPersistenceManager.loadEntity(CMPPersistenceMan
ager
.java:362)
[JAWS] at
org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invoke(EntitySync
hron
izationInterceptor.java:286)
[JAWS] at
org.jboss.ejb.plugins.EntityInstanceInterceptor.invoke(EntityInstanceInt
erce
ptor.java:208)
[JAWS] at
org.jboss.ejb.plugins.EntityLockInterceptor.invoke(EntityLockInterceptor
.jav
a:136)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:
133)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptor
CMT.
java:307)
[JAWS] at
org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
[JAWS] at
org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.jav
a:12
8)
[JAWS] at
org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
[JAWS] at
org.jboss.ejb.EntityContainer.invoke(EntityContainer.java:427)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContai
nerI
nvoker.java:395)
[JAWS] at
org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContai
nerI
nvoker.java:476)
[JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.GenericProxy.invokeContainer(Gener
icPr
oxy.java:335)
[JAWS] at
org.jboss.ejb.plugins.jrmp.interfaces.EntityProxy.invoke(EntityProxy.jav
a:13
3)
[JAWS] at $Proxy33.getName(Unknown Source)
[JAWS] at
_0002fteacher_0005flogin_0002ejspteacher_0005flogin_jsp_0._jspService(_0
002f
teacher_0005flogin_0002ejspteacher_0005flogin_jsp_0.java:164)
[JAWS] at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServle
t.ja
va:130)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServle
t.ja
va:282)
[JAWS] at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
[JAWS] at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
[JAWS] at org.apache.tomcat.core.Handler.service(Handler.java:287)
[JAWS] at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[JAWS] at
org.apache.tomcat.facade.RequestDispatcherImpl.doInclude(RequestDispatch
erIm
pl.java:400)
[JAWS] at
org.apache.tomcat.facade.RequestDispatcherImpl.include(RequestDispatcher
Impl
.java:270)
[JAWS] at
org.apache.jasper.runtime.PageContextImpl.include(PageContextImpl.java:4
14)
[JAWS] at
_0002findex_0002ejspindex_jsp_0._jspService(_0002findex_0002ejspindex_js
p_0.
java:62)
[JAWS] at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at
org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServle
t.ja
va:130)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServle
t.ja
va:282)
[JAWS] at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
[JAWS] at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
[JAWS] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
[JAWS] at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
[JAWS] at org.apache.tomcat.core.Handler.service(Handler.java:287)
[JAWS] at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
[JAWS] at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.jav
a:81
2)
[JAWS] at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:758)
[JAWS] at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(H
ttpC
onnectionHandler.java:213)
[JAWS] at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416
)
[JAWS] at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:50
1)
[JAWS] at java.lang.Thread.run(Thread.java:484)
-----Original Message-----
From: Edson Carlos Ericksson Richter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 15, 2001 6:45 AM
Cc: JBOSS Mail List
Subject: Re: [JBoss-user] MS SQL JDBC Driver problem
I have done some tests, and stated that the problem is port number... I
don't know how much compatible is really MS driver, but appear that are
working for simple tasks...
Best regards,
Edson Richter
----- Original Message -----
From: "Dmitri Colebatch" <[EMAIL PROTECTED]>
To: "David Cao" <[EMAIL PROTECTED]>
Cc: "JBOSS Mail List" <[EMAIL PROTECTED]>
Sent: Wednesday, November 14, 2001 9:05 PM
Subject: RE: [JBoss-user] MS SQL JDBC Driver problem
> sorry I missed the start of this, I'm not sure if any of this will
help,
> but I'll offer it anyway.
>
> I recently had to configure castor to work with SQL server, and face
> similar issues that you would be facing here. One problem I had was
not
> specifying the port - and from the looks of the error, you're not even
> getting past first base. What config are you using for the ms
> driver? fwiw, this is what I use for castor:
>
>
jdbc:microsoft:sqlserver://database.machine:1433;DatabaseName=test;Selec
tMet
hod=cursor
>
> also, the following newsgroup was quite useful I found:
>
> http://www.microsoft.com/sql/downloads/2000/jdbc.asp
>
> the newsgroup microsoft.public.sqlserver.jdbcdriver on
> msnews.microsoft.com is a good source of information on this.
>
> again - not sure if this is going to help, as I've come in a bit late,
but
> anyway.
>
> cheers
> dim
>
> On Wed, 14 Nov 2001, David Cao wrote:
>
> > Edson,
> >
> > Thanks, enclosed with error with SQL Server from two driver:
> >
> > ***For Jdbc-Odbc bridge, error with jboss-2.4.x-tomcat-3.2.3 when
using
> > MS Sql
> > Server:
> > can't load the entity, find works, just can't load, the error
message
> > is:
> > java.rmi.ServerException: Load failed; nested exception is:
> > java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]Invalid
> > Descriptor Index
> >
> >
> > ***And for MS JDBC driver, error when connect use a samal test
program:
> > java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error
> > establishing socket.
> > java.lang.Throwable(java.lang.String)
> > java.lang.Exception(java.lang.String)
> > java.sql.SQLException(java.lang.String, java.lang.String)
> > java.sql.SQLException
> >
com.microsoft.jdbc.base.BaseExceptions.getException(java.sql.SQLExceptio
> > n, int, int, java.lang.String)
> > java.sql.SQLException
> >
com.microsoft.jdbc.base.BaseExceptions.getException(java.sql.SQLExceptio
> > n, int, java.lang.String)
> > com.microsoft.jdbc.sqlserver.tds.TDSConnection(java.lang.String,
> > java.lang.String, boolean, com.microsoft.jdbc.base.BaseExceptions)
> > void com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open()
> > com.microsoft.jdbc.base.BaseImplConnection
> > com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(boolean,
> > int)
> > void
> >
com.microsoft.jdbc.base.BaseConnection.open(com.microsoft.jdbc.base.Base
> > ConnectionProperties, com.microsoft.jdbc.base.BaseExceptions,
> > com.microsoft.util.UtilDebug)
> > java.sql.Connection
> > com.microsoft.jdbc.base.BaseDriver.connect(java.lang.String,
> > java.util.Properties)
> > java.sql.Connection
> > java.sql.DriverManager.getConnection(java.lang.String,
> > java.util.Properties, java.lang.ClassLoader)
> > java.sql.Connection
> > java.sql.DriverManager.getConnection(java.lang.String,
java.lang.String,
> > java.lang.String)
> > java.sql.Connection com.ctbs.jdbc.test.DBAccess.connect()
> > java.sql.ResultSet
> > com.ctbs.jdbc.test.DBAccess.executeQuery(java.lang.String)
> > void com.ctbs.jdbc.test.DBAccess.main(java.lang.String [])
> >
> > -----Original Message-----
> > From: Edson Carlos Ericksson Richter
[mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 14, 2001 10:58 AM
> > To: David Cao; JBOSS Mail List
> > Subject: Re: [JBoss-user] MS SQL JDBC Driver problem
> >
> >
> > Hummm. Trying to cut-off MSSQL is not a idea???
> > Well, JDBC Driver for SQL2K still beta...
> >
> > And JDBC-ODBC bridge should not work because is not thread safe...
> >
> > I'll try something here... But have you not any message error or
> > something???
> >
> >
> > Edson Richter
> >
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
