[Opensource] SQL Server 2000
larry hamel
expresso at codeguild.com
Mon Jan 6 15:47:02 PST 2003
great, so you got past that last issue.
this one is a mapping issue. the 'N' is not a binary value for SQLServer. something is broken, either in your expresso-config.xml mapping, or a bug.
double-check your mapping for "binary", checking against the web page for SQLServer on the jcorporate.com site, and against the previous posts by users of SQLServer.
can others using SQLServer run DBCreate successfully? I assume so...
larry
At 11:31 AM 1/6/2003, you wrote:
>Sorry, I didn't complete my post. Running DBCreate I got
>
>com.jcorporate.expresso.core.db.DBException: Unable to execute statement:
>INSERT INTO USERSTABLE (EmailValCode, Passwd, AccountStatus, LoginName,
>UserName, RegComplete, UpdateDate, CreateDate, RegDomId, EMail, ExpUid)
>VALUES (null, null, 'D', 'Anonymous', 'Anonymous User', 'N', '2003-01-06',
>'2003-01-06', 1, 'none', 1)
>(com.jcorporate.expresso.core.dataobjects.jdbc.JDBCExecutor, db/context
>'sqlserver'):[Microsoft][SQLServer 2000 Driver for
>JDBC][SQLServer]Disallowed implicit conversion from data type varchar to
>data type binary, table 'EXPRESSO.dbo.USERSTABLE', column 'UpdateDate'. Use
>the CONVERT function to run this query.
>
>
>____________________________________________________
>Nelio Alves
>Equifax do Brasil - System Analyst
>+55 -11 3016-6180
>nalves at equifax.com.br
>----- Forwarded by Nelio Alves/SCI/BR on 06/01/2003 17:25 -----
>
> Nelio Alves
> To: opensource at jcorporate.com
> 06/01/2003 cc: opensource-admin at jcorporate.com
> 17:14 Subject: Re: [Opensource] SQL Server 2000(Document link:
> Nelio Alves)
>
>
>
>
>The identity problem was solved adding the mapping. As I said before, I
>didn't create any other config file. Now I'm having the error:
>
>2003-01-06 17:09:11,774 ERROR [main] dbobj.Setup (Setup.java:442) -
>WARNING: Unable to read setup values for db 'sqlserver'
>com.jcorporate.expresso.core.db.DBException: No setup values were readin db
>'sqlserver'. Run DBCreate to setup default setup values.
>
>What am I missing?
>
>Thanks
>____________________________________________________
>Nelio Alves
>Equifax do Brasil - System Analyst
>+55 -11 3016-6180
>nalves at equifax.com.br
>
>
>
> Michael Rimov
> <rimovm at centercomp.co To: opensource at jcorporate.com
> m> cc:
> Sent by: Subject: Re: [Opensource] SQL Server 2000
> opensource-admin at jcor
> porate.com
>
>
> 04/01/2003 22:58
> Please respond to
> opensource
>
>
>
>
>
>
>At 05:17 PM 1/3/2003 -0200, you wrote:
>>I'm having troubles to use SQL Server as a database context. First I
>>created the context as
>>
>> <context name="sqlserver">
>> <description>MS SQL Server 2000</description>
>> <jdbc driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" url
>>="jdbc:microsoft:sqlserver://SERVER:1433;User=USER;Password=PASSWORD"
>>connectFormat="1" login="USER" password="PASSWORD" dateSelectFormat
>>="dd-MM-yyyy" dateUpdateFormat="dd-MM-yyyy" dateTimeSelectFormat
>>="yyyy-MM-dd" dateTimeUpdateFormat="yyyy-MM-dd" cache="y">
>> <dbWildcard>%</dbWildcard>
>> <dbWildcard>*</dbWildcard>
>> </jdbc>
>> <type-mapping>
>> <java-type>LONGVARCHAR</java-type>
>> <expresso-type>text</expresso-type>
>> <db-type>text</db-type>
>> </type-mapping>
>> <images>%context%/%expresso-dir%/images</images>
>> <startJobHandler>y</startJobHandler>
>> <showStackTrace>y</showStackTrace>
>> <mailDebug>n</mailDebug>
>> </context>
>>
>>
>>but I had problems to start expresso. Then I found about the
>hasSetupTables
>>option, and I could start Expresso by adding
>>
>><hasSetupTables>false</hasSetupTables>
>>
>>to the context configuration.
>>
>>
>>
>>Now, when I try to create the tables in this context (Setup -> Create
>>Database Structure), I get the error
>>
>>javax.servlet.ServletException: Unable to execute statement: CREATE TABLE
>>DOWNLOADFILES(FileNumber int identity not null, FilePathName text not
>null,
>>DisplayName nvarchar(128), FileURL text, Descrip nvarchar(80) not null,
>>FileType nvarchar(30), Project nchar(10), GroupName nchar(10) not null,
>>LastUpdated binary, DLNotes text, MimeNumber int identity not null,
>>IsActive nchar(1) not null, IsRestricted
>>bit)(com.jcorporate.expresso.core.dbobj.Schema.createTable(), db/context
>>'sqlserver'):[Microsoft][SQLServer 2000 Driver for
>JDBC][SQLServer]Multiple
>>identity columns specified for table 'DOWNLOADFILES'. Only one identity
>>column per table is allowed.
>
>You're going to have to add a mapping to override the MSSQL JDBC driver
>mapping integers to 'identity'. It will look something like this:
>
>
><type-mapping>
> <expresso-type>int</expresso-type>
> <db-type>integer</db-type>
></type-mapping>
>
>I don't have MS-SQL installed on my system yet, so I can't confirm what the
>
>exact mapping would be, but the principle is the same.
>
>HTH!
> -Mike
>
>
>_______________________________________________
>Opensource mailing list
>Opensource at jcorporate.com
>http://mail.jcorporate.com/mailman/listinfo/opensource
>Archives: http://mail.jcorporate.com/pipermail/opensource/
>
>*************************************************************
>O sigilo desta mensagem é protegido por lei. Se você a recebeu por engano,
>queira apagá-la e informar-nos por e-mail endereçado ao remetente.
>*************************************************************
>The confidentiality of this message is protected by law. If you've received
>it in error, please delete it and inform us by e-mail addressed to its
>sender.
>*************************************************************
>
>
>
>
>*************************************************************
>O sigilo desta mensagem é protegido por lei. Se você a recebeu por engano,
>queira apagá-la e informar-nos por e-mail endereçado ao remetente.
>*************************************************************
>The confidentiality of this message is protected by law. If you've received
>it in error, please delete it and inform us by e-mail addressed to its
>sender.
>*************************************************************
>
>
>
>
>
>*************************************************************
>O sigilo desta mensagem é protegido por lei. Se você a recebeu por engano,
>queira apagá-la e informar-nos por e-mail endereçado ao remetente.
>*************************************************************
>The confidentiality of this message is protected by law. If you've received
>it in error, please delete it and inform us by e-mail addressed to its
>sender.
>*************************************************************
>
>
>
>_______________________________________________
>Opensource mailing list
>Opensource at jcorporate.com
>http://mail.jcorporate.com/mailman/listinfo/opensource
>Archives: http://mail.jcorporate.com/pipermail/opensource/
More information about the Opensource
mailing list