Stack Overflow
Stack Overflow

Questions tagged [maxdb]

MaxDB is a RDBMS (Relational DataBase Management System) from SAP AG targeted for large SAP environments.

17 questions
4
votes
3 answers

Select columns by min value - group by

When I read this post: SQL: Group by minimum value in one field while selecting distinct rows the following solution did not make sense to me and I wonder how it can possibly work: SELECT id, min(record_date), other_cols FROM mytable GROUP BY…
abulhol
  • 171
  • 1
  • 7
2
votes
0 answers

how to select LOB data

I have MaxDB and Java. I try to select data from table with this request: sql_execute SELECT * FROM SAPPOPDB.T_CHUNK where T_CHUNK.CHUNK_DATA < '10000' but got this response: -24988,ERR_SQL: SQL error -7032,SQL statement not allowed for column of…
Vahagn
  • 57
  • 8
2
votes
0 answers

Large result sets with Hibernate and MaxDB

I need to synchronize a large XML file (containing 6 million records sorted by ID) against a SAP MaxDB database table. This is my present strategy: read XML object from file and convert to Java bean load object with the same primary key from…
Matthias Wuttke
  • 1,982
  • 2
  • 21
  • 38
1
vote
1 answer

Configure hibernate to process like with [] (square brackets) against maxDB and sql-server in the same way

I have the following jpql with a LIKE SELECT someField FROM someEntity WHERE otherField LIKE '%foo[bar]' I want to retrieve all rows ending with 'foo[bar]'. For maxDb this is OK. But for sql-server the square brackets are interpreted as…
Benjamin Schmidt
  • 11
  • 2
1
vote
2 answers

MaxDB - User does not access tables

I have created a new user in a MaxDb database. I assign a role that has access to all the tables in roleprivileges but the user can not see these tables. The user can access the tables if I assign permissions directly to the tables in…
David Horno
  • 11
  • 1
1
vote
1 answer

SQL Query max id max date max time (sap maxdb 7.8)

i have a hard time figuring out this one which is around a date/time problem. My Table (Service) got the following structure: ShopID | ServiceID | Datestart | Timeend | StatusID 1 | 100 | 2014-03-03 | 09:16:22 | 15 1 | …
user3480940
  • 11
  • 3
1
vote
0 answers

How to restore MaxDB instance when no backup medium is available?

I have a question about moving MaxDB databse instance from a broken server, when the files of that server have been restored, to a newly installed server? The question I asked is here: http://scn.sap.com/thread/3249060 Is it possible to restore…
Sylwester Gryzio
  • 997
  • 6
  • 12
1
vote
1 answer

Connecting to SAPDB using ODBC

I'd like to access a SAPDB database using ODBC so I've installed the latest ODBC driver from http://www.sapdb.org/ I'm trying to create a connection using the following connection string: DRIVER={SAP DB…
user1517291
  • 11
  • 1
  • 1
  • 2
1
vote
1 answer

PHP PDO Params - Empty strings in $data array cause query to fail

I have a PDO issue with PHP 5.3. I am running MaxDB 7.8 for my database - if you haven't heard of that, you're not alone. It's an open-source enterprise database that is connected with MySQL on paper, but is nothing like it. I'm not sure that this…
Joel
  • 199
  • 2
  • 10
0
votes
0 answers

MaxDB SAP SQL Missing keyword WITH on update

Hi there I'm using MaxDB and trying to update a table and I get the error Missing keyword:WITH. Code: -5015. Here is my SQL: UPDATE agm SET agm_confirm_stat = 'C', agm_confirm_usr = 'MEDICWARE', agm_confirm_obs = 'Wellon: Confirmado', …
Nathan
  • 97
  • 2
  • 9
0
votes
0 answers

DataGrip ER-diagram does not show edges for relationships

I am using a commercial SAP MaxDB database with a custom .jar-file as a driver for the database. I am also not able to change the database keys as I only have read-only privileges. I am having trouble to generate an ERD-Diagram for this database…
Ohumeronen
  • 1,769
  • 2
  • 14
  • 28
0
votes
1 answer

How to connect Maxdb to SQL or Oracle Database?

Presently I'm using Maxdb on SAP. I would like to migrated to SQL or Oracle. How can I do that?
Sudheer Punuru
  • 1
  • 1
0
votes
1 answer

DB2 equivalent for CREATE FORCE VIEW

I am in process of migration MaxDB database to DB2. I need to recreate all views, but their definitions contain references to other views and have the same create date and time, so I'm unable to create them in correct order. Does the DB2 support…
Michal Joštiak
  • 161
  • 9
0
votes
0 answers

Jboss 4.0.2 Transaction marked for rollback, possibly a timeout

I encountered with inconsistent transaction rollback exception in my system. It is run on JBoss v 4.0.2 with MaxDB v.7.8. The MDB process the message and call some method which updates entity bean property. I tried to change the timeout property,…
Pavel Melech
  • 51
  • 4
0
votes
0 answers

calling MaxDB stored procedure with JPA/JPQL/StoredProcedureQuery

I get an "Invalid SQL statement" Exception while I try to invoke an MaxDB DBPROC (stored procedure) with a StoredProcedureQuery (JPA/JPQL). Its that not the correct way to do this? Java Environment: > …
STR
  • 1
  • 1
1
2