You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by bu...@apache.org on 2004/06/18 10:56:03 UTC

DO NOT REPLY [Bug 29663] New: - about preparestatement

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=29663>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=29663

about preparestatement

           Summary: about preparestatement
           Product: Commons
           Version: 1.2 Final
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Dbcp
        AssignedTo: commons-dev@jakarta.apache.org
        ReportedBy: tanihara@imkk.jp


Hello,

I send preparedstatement against MSSQLServer by using dbcp library.
But, I couldn't got a data from MSSQLServer and I got the following exception.

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for 
JDBC]??????????????????????????????????
	at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown 
Source)
	at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown 
Source)
	at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown 
Source)
	at com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source)
	at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
	at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown 
Source)
	at 
org.apache.commons.dbcp.cpdsadapter.PooledConnectionImpl.prepareStatement
(PooledConnectionImpl.java:231)
	at org.apache.commons.dbcp.cpdsadapter.ConnectionImpl.prepareStatement
(ConnectionImpl.java:302)
	at RunSql.getTableData(RunSql.java:38)
	at SelectDataAction.run(SelectDataAction.java:25)
	at org.eclipse.jface.action.Action.runWithEvent(Action.java:842)
	at 
org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection
(ActionContributionItem.java:456)
	at org.eclipse.jface.action.ActionContributionItem.handleWidgetEvent
(ActionContributionItem.java:403)
	at org.eclipse.jface.action.ActionContributionItem.access$0
(ActionContributionItem.java:397)
	at 
org.eclipse.jface.action.ActionContributionItem$ActionListener.handleEvent
(ActionContributionItem.java:72)
	at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:81)
	at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:840)
	at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:2022)
	at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:1729)
	at org.eclipse.jface.window.Window.runEventLoop(Window.java:583)
	at org.eclipse.jface.window.Window.open(Window.java:563)
	at SampleWindow.main(SampleWindow.java:75)

I tested it against oracle and I got a data successfully.
And, when I tested it by using the program which I created without dbcp 
library, I got a data from MSSQLServer.
Is it a bug?

Thanks & Regards
Keiichi Tanihara

---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org